MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

13 rows where Artist Alpha Sort = 8507

View and edit SQL

Suggested facets: Is Highlight, Is Public Domain, Department, Object Name, Title, Culture, Artist Prefix, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
101947 07.225.195a 0 1 189471 European Sculpture and Decorative Arts 3 Torchère figure  7192 Torchère figure (one of a pair) French 7         Artist 2 Style of Augustin Pajou French, Paris 1730–1809 Paris   Pajou, Augustin 8507 French 2 1730 1809 19th century 1800 1899 Plaster, carved and gilded wood 20914 H. 67 in. (170.2 cm.) Gift of J. Pierpont Morgan, 1906                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
110711 41.190.35 0 1 198912 European Sculpture and Decorative Arts 3 Bust 5 Pierre François Basan (1723–1797) French 7         Artist 2 Imitator of Augustin Pajou French, Paris 1730–1809 Paris   Pajou, Augustin 8507 French 2 1730 1809 20th century, after 18th century model 1900 1941 Terracotta 160 Height (with socle): 29 in. (73.7 cm) Bequest of George Blumenthal, 1941                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
110840 42.38.1 0 1 199055 European Sculpture and Decorative Arts 3 Group 3937 Bacchante French 7         Artist 2 Imitator of Augustin Pajou French, Paris 1730–1809 Paris   Pajou, Augustin 8507 French 2 1730 1809 19th century (?), after a model of 1774 1800 1899 Terracotta 160 Height: 23 7/8 in. (60.6 cm) Bequest of Caroline Lucy Morgan, in memory of her parents, 1942                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
113585 56.105 1 1 201895 European Sculpture and Decorative Arts 3 Bust 5 Madame de Wailly, née Adélaïde-Flore Belleville (1765–1838) French, Paris 114         Artist 2   Augustin Pajou French, Paris 1730–1809 Paris   Pajou, Augustin 8507 French 2 1730 1809 1789 1789 1789 Bust: marble; base: grey marble 22637 Overall, without base (confirmed): H. 24 5/8 x W. 19 7/8 x D. 10 3/4 in. (62.5 x 50.5 x 27.3 cm); Height with base: 30 1/8 in. (76.5 cm) Fletcher Fund, 1956                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
117784 1978.2 0 1 206711 European Sculpture and Decorative Arts 3 Statuette 14 Ceres French, Paris 114         Artist 2   Augustin Pajou French, Paris 1730–1809 Paris   Pajou, Augustin 8507 French 2 1730 1809 ca. 1768–70 1763 1775 Buff terracotta with reddish patination 23407 Overall: 24 5/8 × 7 1/2 × 7 1/2 in. (62.5 × 19.1 × 19.1 cm) Purchase, C. Michael Paul Gift, Josephine Bay Paul and C. Michael Paul Foundation Inc. Gift, and Charles Ulrick and Josephine Bay Foundation Inc. Gift, 1978                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
118579 1986.282 0 1 207593 European Sculpture and Decorative Arts 3 Statuette group 3389 Fidelity, the Mother of Constant Love French, Paris 114         Artist 2   Augustin Pajou French, Paris 1730–1809 Paris   Pajou, Augustin 8507 French 2 1730 1809 1799 1799 1799 Terracotta 160 15 1/2 x 7 1/2 x 8 in. (39.4 x 19.1 x 20.3 cm) Purchase, Gifts of J. Pierpont Morgan and Irwin Untermyer, by exchange, 1986                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
121778 2003.25 0 1 211495 European Sculpture and Decorative Arts 3 Bust 5 Head of a Bearded Elder French, probably Paris 485         Artist 2   Augustin Pajou French, Paris 1730–1809 Paris   Pajou, Augustin 8507 French 2 1730 1809 1768 1768 1768 Terracotta on a bleu turquin marble socle 24281 Overall, without socle (confirmed): 14 1/4 x 12 1/8 x 9 1/2 in. (36.2 x 30.8 x 24.1 cm); Height with socle: 21 1/2 in. (54.6 cm) Purchase, Lila Acheson Wallace Gift, 2003                       Sculpture-Miniature 311   Metropolitan Museum of Art, New York, NY 1
140369 07.225.195b 0 1 239210 European Sculpture and Decorative Arts 3 Torchère figure  7192 Torchère figure (one of a pair) French 7         Artist 2 Style of Augustin Pajou French, Paris 1730–1809 Paris   Pajou, Augustin 8507 French 2 1730 1809 19th century 1800 1899 Plaster, carved and gilded wood 20914 Overall (wt. confirmed): H. 67 in., Wt. 179lb. (170.2 cm, 81.1939kg); Overall (integral base): W. 17 × D. 11 5/8 in. (43.2 × 29.5 cm) Gift of J. Pierpont Morgan, 1906                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
140453 20.128.2b 0 1 239342 European Sculpture and Decorative Arts 3 Pedestal 684 Pedestal French 7         Artist 2 After Augustin Pajou French, Paris 1730–1809 Paris   Pajou, Augustin 8507 French 2 1730 1809 19th century 1800 1899 Marble 750 Overall (wt. confirmed): 48 1/4 × 17 × 17 × 11 3/4 in., 623lb. (122.6 × 43.2 × 43.2 × 29.8 cm, 282.5909kg) Gift of Ogden Mills, 1920                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
210530 37.165.104 0 1 337913 Drawings and Prints 11 Drawing 23 Design for a Vase and Supporting Console           Artist 2   Augustin Pajou French, Paris 1730–1809 Paris   Pajou, Augustin 8507 French 2 1730 1809 n.d. 1745 1809 Pen and brown ink, brown wash, over black chalk, heightened with white gouache 29655 12 7/16 x 7 1/8 in. (31.6 x 18.1 cm) Rogers Fund, 1937                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
210531 1979.388 0 1 337914 Drawings and Prints 11 Drawing 23 Project for a Monumental Fountain           Artist 2   Augustin Pajou French, Paris 1730–1809 Paris   Pajou, Augustin 8507 French 2 1730 1809 1767 1767 1767 Pen, brown and black ink, brush, brown and gray wash 31277 15 11/16 x 24 in. (39.8 x 61 cm) Harry G. Sperling Fund, 1979                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
210533 1996.24 0 1 337916 Drawings and Prints 11 Drawing 23 Le Grand Pénitencier           Artist 2   Augustin Pajou French, Paris 1730–1809 Paris   Pajou, Augustin 8507 French 2 1730 1809 n.d. 1740 1809 Black chalk, pen and gray wash 31278 4 13/16 x 7 in. (12.2 x 17.8 cm.) Purchase, Sally Sample Aall, Anne and Jean Bonna, Sarah and Werner H. Kramarsky, and Adriana Mnuchin Foundation Gifts, and Van Day Truex Fund, 1996                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
388199 SL.1.2016.35.5 0 0 638229 European Paintings 15   Madame Vigée Le Brun           Artist 2   Augustin Pajou French, Paris 1730–1809 Paris   Pajou, Augustin 8507   1730 1809 1783 1783 1783 Terracotta 160 Height 21 7/8 in. (55.5 cm); height with pedestal 27 3/4 in. (70.5 cm) Musée du Louvre, Paris, Département des Sculptures (RF 2909)                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 144.692ms · Data license: CC0 · Data source: metmuseum/openaccess